Mapping Additional Flex-fields

UNIT Reportable Entity

You can map up to 15 additional fields to be extracted as part of the billing extract. The field names specified in the XML mapping file must exactly match the N4 Unit reportable entity external tag names and have the same data type. The following sample billing extract XML mapping displays the available flex fields that can be used to map existing N4 fields. The flexfield-mappings block consists of 15 flex field IDs, five each of type string, date, and long. For example, the bexuFlexString01 flex field is of the type string and can only be mapped to N4 fields that are of the type string.

<flexfield-mappings>

<flexfield-mapping id="bexuFlexString01"value="FreightKind"/>

<flexfield-mapping id="bexuFlexString02"value="EquipmentOwner"/>

<flexfield-mapping id="bexuFlexString03"value=""/>

<flexfield-mapping id="bexuFlexString04"value=""/>

<flexfield-mapping id="bexuFlexString05"value=""/>

<flexfield-mapping id="bexuFlexDate01"value="InboundCarrierETA"/>

<flexfield-mapping id="bexuFlexDate02"value=""/>

<flexfield-mapping id="bexuFlexDate03"value=""/>

<flexfield-mapping id="bexuFlexDate04"value=""/>

<flexfield-mapping id="bexuFlexDate05"value=""/>

<flexfield-mapping id="bexuFlexLong01"value="EquipmentTareWeightKg"/>

<flexfield-mapping id="bexuFlexLong02"value=""/>

<flexfield-mapping id="bexuFlexLong03"value=""/>

<flexfield-mapping id="bexuFlexLong04"value=""/>

<flexfield-mapping id="bexuFlexLong05"value=""/>

</flexfield-mappings>

To load a user-defined billing extract XML mapping file:

  1. Create the billing extract XML mapping file using any XML editor. You can also copy the sample mapping file shown above and edit the fields you want to extract.

  1. In the ADMINISTRATION SETTINGS SETTINGS VIEW, select the INVBILLING001 (BILLING_EXTRACT_MAP) configuration setting and click .

  2. In the Edit Configuration form, select the scope level at which you want to add the billing extract XML mapping file. The mapping file will be inherited by all the lower scope levels. For more information, see Edit Configuration form (on page ix).

  3. Click Override to override the existing configuration for the INVBILLING001 (BILLING_EXTRACT_MAP) setting.

  4. Click to import the billing extract XML mapping file.

  5.  In the Import XML Configuration dialog box, select the billing extract XML mapping file and click Open. The text field displays -loaded- to indicate that the mapping file is associated at the selected scope level.

  6. Click Save.

 

Vessel Reportable Entity

You can map up to 15 additional fields to be extracted as part of the billing extract. The field names specified in the XML mapping file must exactly match the N4 reportable VesselVisitDetails entity external tag names and have the same data type. The following sample billing extract XML mapping displays the available flex fields that can be used to map existing N4 fields. The flexfield-mappings block consists of 15 flex field IDs, five each of type string, date, and long. For example, the bexmFlexString01 flex field is of the type string and can only be mapped to N4 fields that are of the type string.

<flexfield-mappings>

<flexfield-mapping id="bexmFlexString01"value="VesselServiceName"/>

<flexfield-mapping id="bexmFlexString02"value="VesselRadioCallSign"/>

<flexfield-mapping id="bexmFlexString03"value=""/>

<flexfield-mapping id="bexmFlexString04"value=""/>

<flexfield-mapping id="bexmFlexString05"value=""/>

<flexfield-mapping id="bexmFlexDate01"value="TimePilotOnBoard"/>

<flexfield-mapping id="bexmFlexDate02"value=""/>

<flexfield-mapping id="bexmFlexDate03"value=""/>

<flexfield-mapping id="bexmFlexDate04"value=""/>

<flexfield-mapping id="bexmFlexDate05"value=""/>

<flexfield-mapping id="bexmFlexLong01"value="EstimatedShiftCount"/>

<flexfield-mapping id="bexmFlexLong02"value=""/>

<flexfield-mapping id="bexmFlexLong03"value=""/>

<flexfield-mapping id="bexmFlexLong04"value=""/>

<flexfield-mapping id="bexmFlexLong05"value=""/>

</flexfield-mappings>

To load a user-defined billing extract XML mapping file:

  1. Create the billing extract XML mapping file using any XML editor. You can also copy the sample mapping file shown above and edit the fields you want to extract.

  1. In the ADMINISTRATION SETTINGS SETTINGS VIEW, select the VESLBILLING005 (BILLING_EXTRACT_MAP) configuration setting and click .

  2. In the Edit Configuration form, select the scope level at which you want to add the billing extract XML mapping file. The mapping file will be inherited by all the lower scope levels. For more information, see Edit Configuration form (on page ix).

  3. Click Override to override the existing configuration for the VESLBILLING005 (BILLING_EXTRACT_MAP) setting.

  4. Click to import the billing extract XML mapping file.

  5.  In the Import XML Configuration dialog box, select the billing extract XML mapping file and click Open. The text field displays -loaded- to indicate that the mapping file is associated at the selected scope level.

  6. Click Save.